package org.jeecg.modules.system.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.system.entity.SysRegion;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @Description: voc_region
 * @Author: jeecg-boot
 * @Date:   2023-02-02
 * @Version: V1.0
 */
public interface SysRegionMapper extends BaseMapper<SysRegion> {

    @Deprecated
    @Select("select ${key} as \"label\",${value} as \"value\" from ${table} where pid ='${pid}'")
    public List<Map<String,String>> getDictRegion(@Param("table") String table,
                                                  @Param("key") String key,
                                                  @Param("value") String value,
                                                  @Param("pid") String pid);


}
